package com.jdrx.sw.sewage.dao;

import com.jdrx.sw.sewage.beans.entity.CategoryPO;
import com.jdrx.sw.sewage.beans.vo.CategoryVO;
import com.jdrx.sw.sewage.beans.vo.MaterielAndCategoryVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;


/**
 * 物料DAO（sewage_materiel）
 * Created by generator on 2020-10-12.
 */
@Mapper
public interface CategoryDAO {
    int insert(CategoryPO record);

    List<CategoryPO> selectNameList(@Param("materielId") Long materielId);

    CategoryVO selectByName(String name);

    List<CategoryPO> selectList(@Param("materielId") Long materielId);

    Long selectNextId();

    List<MaterielAndCategoryVO> findDevStorageAndMateriel();
}